1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11
12 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
13 "http://www.w3.org/TR/html4/loose.dtd">
14 <html>
15 <head>
16 <title>Welcome to Stock Management System !</title>
17 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
18 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
20 <script src="js/jquery.min.js" type="text/javascript"></script>
21
22 <script type='text/javascript' src='lib/jquery.bgiframe.min.js'></script>
23 <script type='text/javascript' src='lib/jquery.ajaxQueue.js'></script>
24 <script type='text/javascript' src='lib/thickbox-compressed.js'></script>
25 <script type='text/javascript' src='jquery.autocomplete.js'></script>
26 <script type='text/javascript' src='localdata.js'></script>
27
28 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
29 <link rel="stylesheet" type="text/css" href="lib/thickbox.css" />
30
31 <script type="text/javascript">
32 $().ready(function() {
33
34 function log(event, data, formatted) {
35 $("<li>").html( !data ? "No match!" : "Selected: " + formatted).appendTo("#result");
36 }
37
38 function formatItem(row) {
39 return row[0] + " (<strong>id: " + row[1] + "</strong>)";
40 }
41 function formatResult(row) {
42 return row[0].replace(/(<.+?>)/gi, '');
43 }
44
45
46
47 $("#singleBirdRemote").autocomplete("category.php", {
48 width: 160,
49 autoFill: true,
50 selectFirst: false
51 });
52 $("#supplier").autocomplete("supplier1.php", {
53 width: 160,
54 autoFill: true,
55 selectFirst: false
56 });
57 $("#uom").autocomplete("uom.php", {
58 width: 160,
59 autoFill: true,
60 selectFirst: false
61 });
62
63
64 $("#clear").click(function() {
65 $(":input").unautocomplete();
66 });
67 });
68
69
70 </script>
71
72 <script LANGUAGE="JavaScript">
73 <!--
74 // Nannette Thacker http://www.shiningstar.net
75 function confirmSubmit()
76 {
77 var agree=confirm("Are you sure you wish to Delete this Entry?");
78 if (agree)
79 return true ;
80 else
81 return false ;
82 }
83
84 function confirmDeleteSubmit()
85 {
86 var agree=confirm("Are you sure you wish to Delete Seletec Record?");
87 if (agree)
88
89 document.deletefiles.submit();
90 else
91 return false ;
92 }
93
94
95 function checkAll()
96 {
97
98 var field=document.forms.deletefiles;
99 for (i = 0; i < field.length; i++)
100 field[i].checked = true ;
101 }
102
103 function uncheckAll()
104 {
105 var field=document.forms.deletefiles;
106 for (i = 0; i < field.length; i++)
107 field[i].checked = false ;
108 }
109 // -->
110 </script>
111
112
113 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
114 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
115 <script src="js/jquery.hotkeys-0.7.9.js"></script>
116 <!-- AJAX SUCCESS TEST FONCTION
117 <script>function callSuccessFunction(){alert("success executed")}
118 function callFailFunction(){alert("fail executed")}
119 </script>
120 -->
121
122 <script>
123
124
125
126
127
128 $(document).ready(function() {
129 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
130 $("#name").focus();
131 $("#form1").validationEngine(),
132
133 jQuery(document).bind('keydown', 'Ctrl+s',function() {
134 $('#form1').submit();
135 return false;
136 });
137
138 jQuery(document).bind('keydown', 'Ctrl+r',function() {
139 $('#form1').reset();
140 return false;
141 });
142 jQuery(document).bind('keydown', 'Ctrl+a',function() {
143 window.location = "addstock.php";
144 return false;
145 });
146 jQuery(document).bind('keydown', 'Ctrl+0',function() {
147 window.location = "admin.php";
148 return false;
149 });
150 jQuery(document).bind('keydown', 'Ctrl+1',function() {
151 window.location = "add_purchase.php";
152 return false;
153 });
154 jQuery(document).bind('keydown', 'Ctrl+2',function() {
155 window.location = "add_stock_sales.php";
156 return false;
157 });
158 jQuery(document).bind('keydown', 'Ctrl+3',function() {
159 window.location = "add_stock_details.php";
160 return false;
161 });
162 jQuery(document).bind('keydown', 'Ctrl+4',function() {
163 window.location = "add_category.php";
164 return false;
165 });
166 jQuery(document).bind('keydown', 'Ctrl+5',function() {
167 window.location = "add_supplier_details.php";
168 return false;
169 });
170 jQuery(document).bind('keydown', 'Ctrl+6',function() {
171 window.location = "add_customer_details.php";
172 return false;
173 });
174 jQuery(document).bind('keydown', 'Ctrl+7',function() {
175 window.location = "view_stock_entries.php";
176 return false;
177 });
178 jQuery(document).bind('keydown', 'Ctrl+8',function() {
179 window.location = "view_stock_sales.php";
180 return false;
181 });
182 jQuery(document).bind('keydown', 'Ctrl+9',function() {
183 window.location = "view_stock_details.php";
184 return false;
185 });
186 //$.validationEngine.loadValidation("#date")
187 //alert($("#formID").validationEngine({returnIsValid:true}))
188 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
189 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
190 });
191 </script>
192 <style type="text/css">
193 <!--
194 body {
195 margin-left: 0px;
196 margin-top: 0px;
197 margin-right: 0px;
198 margin-bottom: 0px;
199 background-color: #FFFFFF;
200 }
201
202 *{
203 padding: 0px;
204 margin: 0px;
205 }
206 #vertmenu {
207 font-family: Verdana, Arial, Helvetica, sans-serif;
208 font-size: 100%;
209 width: 160px;
210 padding: 0px;
211 margin: 0px;
212 }
213
214 #vertmenu h1 {
215 display: block;
216 background-color:#FF9900;
217 font-size: 90%;
218 padding: 3px 0 5px 3px;
219 border: 1px solid #000000;
220 color: #333333;
221 margin: 0px;
222 width:159px;
223 }
224
225 #vertmenu ul {
226 list-style: none;
227 margin: 0px;
228 padding: 0px;
229 border: none;
230 }
231 #vertmenu ul li {
232 margin: 0px;
233 padding: 0px;
234 }
235 #vertmenu ul li a {
236 font-size: 80%;
237 display: block;
238 border-bottom: 1px dashed #C39C4E;
239 padding: 5px 0px 2px 4px;
240 text-decoration: none;
241 color: #666666;
242 width:160px;
243 }
244
245 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
246 color: #000000;
247 background-color: #eeeeee;
248 }
249 .style1 {color: #000000}
250 div.pagination {
251
252 padding: 3px;
253
254 margin: 3px;
255
256 }
257
258
259
260 div.pagination a {
261
262 padding: 2px 5px 2px 5px;
263
264 margin: 2px;
265
266 border: 1px solid #AAAADD;
267
268
269
270 text-decoration: none; /* no underline */
271
272 color: #000099;
273
274 }
275
276 div.pagination a:hover, div.pagination a:active {
277
278 border: 1px solid #000099;
279
280
281
282 color: #000;
283
284 }
285
286 div.pagination span.current {
287
288 padding: 2px 5px 2px 5px;
289
290 margin: 2px;
291
292 border: 1px solid #000099;
293
294
295
296 font-weight: bold;
297
298 background-color: #000099;
299
300 color: #FFF;
301
302 }
303
304 div.pagination span.disabled {
305
306 padding: 2px 5px 2px 5px;
307
308 margin: 2px;
309
310 border: 1px solid #EEE;
311
312
313
314 color: #DDD;
315
316 }
317
318
319 -->
320 </style>
321 </head>
322
323 <body>
324 <table width="100%" border="0" cellspacing="0" cellpadding="0">
325 <tr>
326 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
327 <tr>
328 <td>
329 <table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
330 <tr>
331 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
332 </tr>
333 <tr>
334 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
335 <tr>
336 <td width="130" align="left" valign="top">
337
338 <br>
339
340 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
341 <table width="100%" border="0" cellspacing="0" cellpadding="0">
342 <tr>
343 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
344 </tr>
345 <tr>
346 <td align="center"> </td>
347 </tr>
348 <tr>
349 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
350 </tr>
351 <tr>
352 <td align="center"> </td>
353 </tr>
354 <tr>
355 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
356 </tr>
357 <tr>
358 <td align="center"> </td>
359 </tr>
360 <tr>
361 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
362 </tr>
363 <tr>
364 <td align="center"> </td>
365 </tr>
366 <tr>
367 <td align="center"> </td>
368 </tr>
369 <tr>
370 <td align="center"> </td>
371 </tr>
372 </table>
373
374
375
376
377
378 </td> <td height="500" align="center" valign="top">
379 <table width="100%" border="0" cellspacing="0" cellpadding="0">
380 <tr>
381 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
382 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
383 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
384 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
385 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
386 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
387 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
388 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
389 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
390 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
391 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
392 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
393 </tr>
394 </table>
395 <br>
396 <br>
397
398 <table width="700" border="0" cellspacing="0" cellpadding="0">
399 <tr>
400
401 <td><form action="" method="get" name="page">
402 Page per Record<input name="limit" type="text" style="margin-left:5px;" value="<?php if(isset($_GET['limit'])) echo $_GET['limit']; else echo "10"; ?>" size="3" maxlength="3">
403 <input name="go" type="submit" value="Go"><!--
404 <input type="button" name="selectall" value="SelectAll" onClick="checkAll()" style="margin-left:5px;"/>
405 <input type="button" name="unselectall" value="DeSelectAll" onClick="uncheckAll()" style="margin-left:5px;" />
406 <input name="dsubmit" type="button" value="Delete Selected" style="margin-left:5px;" onclick="return confirmDeleteSubmit()"/> --></form></td>
407 </tr>
408 </table>
409 <?php
410
411
412
413 $SQL = "SELECT * FROM transactions";
414
415
416 $tbl_name="transactions"; //your table name
417
418 // How many adjacent pages should be shown on each side?
419
420 $adjacents = 3;
421
422
423
424 /*
425
426 First get total number of rows in data table.
427
428 If you have a WHERE clause in your query, make sure you mirror it here.
429
430 */
431
432 $query = "SELECT COUNT(*) as num FROM transactions";
433 $total_pages = mysql_fetch_array(mysql_query($query));
434
435 $total_pages = $total_pages[num];
436
437
438
439 /* Setup vars for query. */
440
441 $targetpage = "view_payments.php"; //your file name (the name of this file)
442
443 $limit = 10; //how many items to show per page
444 if(isset($_GET['limit']))
445 $limit=$_GET['limit'];
446
447 $page = $_GET['page'];
448
449 if($page)
450
451 $start = ($page - 1) * $limit; //first item to display on this page
452
453 else
454
455 $start = 0; //if no page var is given, set start to 0
456
457
458
459 /* Get data. */
460
461 $sql = "SELECT * FROM transactions ORDER BY date desc LIMIT $start, $limit ";
462
463
464 $result = mysql_query($sql);
465
466
467
468 /* Setup page vars for display. */
469
470 if ($page == 0) $page = 1; //if no page var is given, default to 1.
471
472 $prev = $page - 1; //previous page is page - 1
473
474 $next = $page + 1; //next page is page + 1
475
476 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
477
478 $lpm1 = $lastpage - 1; //last page minus 1
479
480
481
482 /*
483
484 Now we apply our rules and draw the pagination object.
485
486 We're actually saving the code to a variable in case we want to draw it more than once.
487
488 */
489
490 $pagination = "";
491
492 if($lastpage > 1)
493
494 {
495
496 $pagination .= "<div class=\"pagination\">";
497
498 //previous button
499
500 if ($page > 1)
501
502 $pagination.= "<a href=\"$targetpage?page=$prev&limit=$limit\">« previous</a>";
503
504 else
505
506 $pagination.= "<span class=\"disabled\">« previous</span>";
507
508
509
510 //pages
511
512 if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
513
514 {
515
516 for ($counter = 1; $counter <= $lastpage; $counter++)
517
518 {
519
520 if ($counter == $page)
521
522 $pagination.= "<span class=\"current\">$counter</span>";
523
524 else
525
526 $pagination.= "<a href=\"$targetpage?page=$counter&limit=$limit\">$counter</a>";
527
528 }
529
530 }
531
532 elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
533
534 {
535
536 //close to beginning; only hide later pages
537
538 if($page < 1 + ($adjacents * 2))
539
540 {
541
542 for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
543
544 {
545
546 if ($counter == $page)
547
548 $pagination.= "<span class=\"current\">$counter</span>";
549
550 else
551
552 $pagination.= "<a href=\"$targetpage?page=$counter&limit=$limit\">$counter</a>";
553
554 }
555
556 $pagination.= "...";
557
558 $pagination.= "<a href=\"$targetpage?page=$lpm1&limit=$limit\">$lpm1</a>";
559
560 $pagination.= "<a href=\"$targetpage?page=$lastpage&limit=$limit\">$lastpage</a>";
561
562 }
563
564 //in middle; hide some front and some back
565
566 elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
567
568 {
569
570 $pagination.= "<a href=\"$targetpage?page=1&limit=$limit\">1</a>";
571
572 $pagination.= "<a href=\"$targetpage?page=2&limit=$limit\">2</a>";
573
574 $pagination.= "...";
575
576 for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
577
578 {
579
580 if ($counter == $page)
581
582 $pagination.= "<span class=\"current\">$counter</span>";
583
584 else
585
586 $pagination.= "<a href=\"$targetpage?page=$counter&limit=$limit\">$counter</a>";
587
588 }
589
590 $pagination.= "...";
591
592 $pagination.= "<a href=\"$targetpage?page=$lpm1&limit=$limit\">$lpm1</a>";
593
594 $pagination.= "<a href=\"$targetpage?page=$lastpage&limit=$limit\">$lastpage</a>";
595
596 }
597
598 //close to end; only hide early pages
599
600 else
601
602 {
603
604 $pagination.= "<a href=\"$targetpage?page=1&limit=$limit\">1</a>";
605
606 $pagination.= "<a href=\"$targetpage?page=2&limit=$limit\">2</a>";
607
608 $pagination.= "...";
609
610 for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
611
612 {
613
614 if ($counter == $page)
615
616 $pagination.= "<span class=\"current\">$counter</span>";
617
618 else
619
620 $pagination.= "<a href=\"$targetpage?page=$counter&limit=$limit\">$counter</a>";
621
622 }
623
624 }
625
626 }
627
628
629
630 //next button
631
632 if ($page < $counter - 1)
633
634 $pagination.= "<a href=\"$targetpage?page=$next&limit=$limit\">next »</a>";
635
636 else
637
638 $pagination.= "<span class=\"disabled\">next »</span>";
639
640 $pagination.= "</div>\n";
641
642 }
643
644
645 ?>
646 <?php if(isset($_GET['msg'])) echo "Record ID:[ ".$_GET['id']." ] <center>".$_GET['msg']."</center>";
647
648 if(isset($_GET['cmsg'])) echo "<center>".$_GET['cmsg']."</center>";
649 ?>
650
651
652
653 <form name="deletefiles" action="deleteselected.php" method="post">
654 <input name="table" type="hidden" value="stock_entries">
655 <input name="return" type="hidden" value="view_stock_entries.php">
656
657
658 <table width="700" border="0" cellspacing="0" cellpadding="0">
659
660 <tr>
661
662 <td bgcolor="#0099FF"><div align="center"><strong><span class="style1">View Stock Sales Payments </span></strong></div></td>
663
664 </tr>
665
666 <tr>
667
668 <td> </td>
669
670 </tr>
671
672 <tr>
673
674 <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
675
676 <tr>
677
678 <td width="100"><strong>Type</strong></td>
679
680 <td width="100"><strong>Date</strong></td>
681
682 <td width="100"><strong>Supplier</strong></td>
683 <td width="100"><strong>Customer</strong></td>
684 <td width="100"><strong>Balance</strong></td>
685 <td width="100"><strong>Payment</strong></td>
686 <td width="100"><strong>Total</strong></td>
687 <td width="100"><strong>Due Date</strong></td>
688 <!-- <td width="100"><strong>View/Edit</strong></td> -->
689 <!-- <td width="100"><strong>Select</strong></td> -->
690 </tr>
691
692
693
694
695
696 <?php
697
698
699
700 while($row = mysql_fetch_array($result))
701
702 {
703 $mysqldate=$row['date'];
704
705 $phpdate = strtotime( $mysqldate );
706
707 $phpdate = date("d/m/Y",$phpdate);
708
709 ?>
710
711 <tr>
712
713
714
715 <td width="100"><?php echo $row['type']; ?></td>
716 <td width="100"><?php echo $phpdate; ?></td>
717 <td width="100"><?php echo $row['supplier']; ?></td>
718 <td width="100"><?php echo $row['customer']; ?></td>
719 <td width="100"><?php echo $row['balance']; ?></td>
720 <td width="100"><?php echo $row['payment']; ?></td>
721 <td width="100"><?php echo $row['subtotal']; ?></td>
722 <td width="100"><?php
723 $mysqldate=$row['due'];
724
725 $phpdate = strtotime( $mysqldate );
726
727 $phpdate = date("d/m/Y",$phpdate);
728
729
730 echo $phpdate; ?></td>
731
732
733
734 <!-- <td width="100"> <a href="update_stock_entries.php?id=<?php// echo $entryid;?>"><img src="images/edit-icon.png" border="0" alt="delete"></a></td>
735 -->
736 <!-- <td width="100"> <input type="checkbox" value="<?php // echo $row['id']; ?>" name="checklist[]" /></td>
737 --> </tr>
738
739
740
741
742
743
744
745
746
747
748
749
750 <?php
751
752
753
754
755
756 }
757
758
759
760
761
762
763
764
765
766
767
768
769
770 ?>
771
772
773
774
775
776
777
778
779
780
781
782 </table></td>
783
784 </tr>
785
786 <tr>
787
788 <td> </td>
789
790 </tr>
791
792 <tr>
793
794 <td align="center"> </td>
795
796 </tr>
797
798 <tr>
799
800 <td align="center"><div style="margin-left:20px;"><?php echo $pagination; ?></div></td>
801
802 </tr>
803
804 <tr>
805
806 <td align="center"> </td>
807
808 </tr>
809
810 <tr>
811
812 <td> </td>
813
814 </tr>
815
816 <tr>
817
818 <td align="center"> </td>
819
820 </tr>
821
822 <tr>
823
824 <td> </td>
825
826 </tr>
827
828 </table>
829
830
831
832 </form>
833
834
835
836 </td>
837
838 </tr>
839
840 </table>
841
842 </td>
843 </tr>
844 </table>
845
846 </td>
847 </tr>
848 <tr>
849 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
850 </tr>
851 </table></td>
852 </tr>
853 </table></td>
854 </tr>
855 </table>
856
857 </body>
858 </html>
859 <?php
860 }
861 ?>